﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GastoUpdate')
	BEGIN
		DROP  Procedure  GastoUpdate
	END
GO

CREATE PROCEDURE GastoUpdate 	
	(	
		@id AS INT,
		@concepto AS VARCHAR(50),
		@monto AS MONEY,
		@tipo AS CHAR(1)
	)	
AS
BEGIN	
	SET NOCOUNT ON
	  
	UPDATE	Lit_Gasto
	SET		Concepto = @concepto,
			Monto = @monto,
			Tipo = @tipo	
	WHERE id = @id
	
	SET NOCOUNT OFF
END
GO